|
JIRA 4.4 : Connecting to named instances in SQL Server
This page last changed on Jun 18, 2011 by ggaskell.
When using named instances you will need to specify the URL slightly differently in the connection properties. First off, try: <url>jdbc:jtds:<server_type>://<server>[:<port>][/<database>];instance=<instance_name></url> This is specified at the JTDS FAQ If this doesn't work, try dropping the instance name, and changing the port to the port used by the named instance: <url>jdbc:jtds:<server_type>://<server>[:<instance_port>][/<database>]</url> Note. This port is different to the normal SQL Server port as each instance listens on a different port. |
| Document generated by Confluence on Aug 18, 2011 23:28 |